How to monitor your Crypto Portfolio using Google Sheets
Having a hard time tracking all your crypto investments across all kinds of different platforms? Are you buying coins in CEX, staking them in DeFI platforms or generating yield income?
It must be hard keeping track of everything.
And while there’s a number of Apps tracking your crypto investment, they only track the funds in major exchanges, leaving cold storage, DEXs and other platforms out of the equation.
That’s why I build a Google Sheets to keep track of my Portfolio. This is how it looks like (no, this is not my actual portfolio):
You can get the spreadsheet from https://docs.google.com/spreadsheets/d/1T-TIGoGbQUAjOTksVVaJoRgTFbeZ60_QqFubr17cL6U/edit?usp=sharing
UPDATE: I built a more advanced spreadsheet which includes a delay indicator and a ATH Loss display.
The delay indicator just reminds you the data is likely to be outdated (it’s not gonna show you the huge dip 10 min ago). Data could be outdated due to 1) issues during update 2) cache on the server (CDN) 3) Google Sheets (only pulls data 1 once per hour), etc.
The ATH Loss display: this is very useful when, imagine you have two coins, one of them is 50% of your portfolio and the other one just 5%. If they both have a similar ATH loss (e.g. 60%), then you could consider divesting from the first coin and investing into the the 2nd one. This is, supposing that both of them have equal likelihood of returning to ATH, and you want a more balanced portfolio.
To help me with serving all the data used in the spreadsheets I built https://cryptoprices.cc/ to give me a simple to use interface to load data from. This in alternative to complex parsing of modern cluttered web pages or signing up for 3rd party API services with all kinds of limits and still do parsing and other logic on the Google Sheets.
Using my service, pulling crypto data is as simple as doing
=IMPORTDATA(“https://cryptoprices.cc/BTC/")
or
=IMPORTDATA(“https://cryptoprices.cc/BTC/ATH/")
to get the All Time High price of Bitcoin.
